Tables [dbo].[FieldSection]
SQLServer > iMIS1521GA > Tables > dbo.FieldSection
Properties
PropertyValue
Created10:31:22 AM Tuesday, March 02, 2010
Last Modified11:40:02 AM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_FieldSection: FieldSectionIdFieldSectionIdint4
No
1 - 1
Indexes iWC: SectionNameSectionNamevarchar(128)128
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_FieldSection: FieldSectionIdPK_FieldSectionFieldSectionId
Yes
iWCSectionName
SQL Script
CREATE TABLE [dbo].[FieldSection]
(
[FieldSectionId] [int] NOT NULL IDENTITY(1, 1),
[SectionName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[FieldSection] ADD CONSTRAINT [PK_FieldSection] PRIMARY KEY CLUSTERED ([FieldSectionId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[FieldSection] ([SectionName]) ON [PRIMARY]
GO
Uses
Used By
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved